﻿IF OBJECT_ID ('CHO_TASK_STATUS') IS NOT NULL
	DROP TABLE CHO_TASK_STATUS
GO

CREATE TABLE CHO_TASK_STATUS
	(
	TASK_STATUS_ID    INT NOT NULL,
	TASK_STATUS_DESC  NVARCHAR (50) NOT NULL,
	CONSTRAINT PK_CHO_TASK_STATUS PRIMARY KEY (TASK_STATUS_ID)
	)
GO

INSERT INTO CHO_TASK_STATUS VALUES (0, 'INVALID')
GO
INSERT INTO CHO_TASK_STATUS VALUES (1, 'INACTIVE')
GO
INSERT INTO CHO_TASK_STATUS VALUES (2, 'ACTIVE')
GO
INSERT INTO CHO_TASK_STATUS VALUES (3, 'RUNNING')
GO
INSERT INTO CHO_TASK_STATUS VALUES (4, 'SUCCESS')
GO
INSERT INTO CHO_TASK_STATUS VALUES (5, 'FAILED')
GO
INSERT INTO CHO_TASK_STATUS VALUES (6, 'STOPPED')
GO
INSERT INTO CHO_TASK_STATUS VALUES (7, 'ABORTED')
GO
INSERT INTO CHO_TASK_STATUS VALUES (8, 'TIMEDOUT')
GO
INSERT INTO CHO_TASK_STATUS VALUES (9, 'SCHEDULED')
GO
INSERT INTO CHO_TASK_STATUS VALUES (10, 'CLEAN')
GO
